package data;

import java.io.File;
import java.io.IOException;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class Import {

	public Workbook ltpSchedule;

	public Sheet instance;
	
	public Cell instanceCell;
	public Cell referenceCmaxCell;
	public Cell machineCell;
	public Cell jobCell;
	public Cell processingTimeCell;

	public String instanceString;
	public String referenceCmaxString;
	public String machineString;
	public String jobString;
	public String processingTimeString;

	public int instanceNum;
	public int referenceCmaxNumber;
	public int machineNumber;
	public int jobNumber;
	public int processingTime;

	private static String filePath = System.getProperty("user.dir") + "/input";
	private final static String ext = ".xls";

	public void address() {

		try {
			this.getExel();
		} catch (BiffException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public void getExel() throws BiffException, IOException {

		ltpSchedule = Workbook.getWorkbook(new File(filePath + ext));
		instance = ltpSchedule.getSheet(0);
	}

	public void doImport() {
		
		this.address();
		this.setInput();
	}
	
	public void setInput()
	{
	
		int i;
		int j;
		int k;
		float h;
		int m;
		float n;
		int d;
				
		
		
	
	}

}
